Timestamping After Commit
نویسنده
چکیده
Many applications need transaction-consistent pictures of past states of the database. These applications use the commit t ime of the transaction i o timestamp the data. When a transaction is distributed, the cohorts must vote on a commit t ime and the coordinator must choose a commit t ime based on the votes of the cohorts. This implies that timestamps are applied after commit. Until the timestamps are on all the records, one must keep a table of all the committed transaction identifiers and their commit times. The main problem solved is that of determining when all timestamps corresponding to a given transaction have been placed in the records so that a committed transaction entry can be erased from the table. This information must be stable. Logging and recovery details are included.
منابع مشابه
Correct and Efficient Timestamping of Temporal Data
Previous approaches to timestamping temporal data have implicitly assumed that transactions have no duration. In this paper we identify several situations where a sequence of operations over time within a single transaction can violate ACID properties. It has been previously shown that the transaction-time dimension must be timestamped after commit. This time is not known within the transaction...
متن کاملConsistent Timestamping for Transactions in Distributed Systems
Tagging data in a database with timestamps that indicate when data was entered can be very useful It permits a user to query the database as of some historical time Further it permits a user to see a transaction consistent re cent version of the database without having this transaction interfere with ongoing updates This support requires that timestamp ordering represent a valid serialization o...
متن کاملPhase Timestamping for Replica Consistency in Interactive Collaborative Applications
Interactive Collaborative applications, such as distributed virtual environments, collaborative CAD and multiplayer games, are enabled by the data being shared across distributed users. The need to support such applications in a wide-area environment, and at the same time provide fast response to users, motivates replication of this shared data. The key characteristics of this shared data inclu...
متن کاملA Secure Round-Based Timestamping Scheme with Absolute Timestamps (Short Paper)
The aim of timestamping systems is to provide a proof-ofexistence of a digital document at a given time. Such systems are important to ensure integrity and non-repudiation of digital data over time. Most of the existing timestamping schemes use the notions of round (a period of time) and round token (a single value aggregating the timestamping requests received during one round). Such schemes h...
متن کاملEeective Timestamping in Databases a Timecenter Technical Report Individual Participants
Many existing database applications place various timestamps on their data, rendering temporal values such as dates and times prevalent in database tables. During the past two decades, several dozen temporal data models have appeared, all with timestamps being integral components. The models have used timestamps for encoding two speci c temporal aspects of database facts, namely transaction tim...
متن کامل